﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Business
{
    class Constants
    {
        public const string DeleteCommand = "DELETE FROM {0} WHERE ID IN ({1})";
        public const string DeleteChildCommand = "DELETE FROM {0} WHERE [{1}] IN ({2})";
        public const string DeleteOrderDetailCommand = "DELETE FROM [OrderDetail] WHERE [OrderId] = {0}";
        public const string DeleteDeliveryDetailCommand = "DELETE FROM [DeliveryDetail] WHERE [DeliveryId] = {0}";
        public const string GetDeliveryDetailByOrdersCommand = "SELECT [OrderId] FROM [DeliveryDetail] WHERE [OrderId] IN ({0}) AND [DeliveryId] <> {1}";

        public const string EmailDelivery = "Thông tin giao hàng";
        public const string CurrencyFormat = "0,000";

        public const string SmsDeliveryInternal1 = "Giao trong thành phố trực tiếp";
        public const string SmsDeliveryInternal2 = "Giao trong thành phố thông báo";
        public const string SmsDeliveryExternal = "Giao ngoài thành phố";

        public const string EmailParameter1 = "<CUSTOMER>";
        public const string EmailParameter2 = "<CHI TIET DON HANG>";
        public const string EmailParameter3 = "\r\n";
        public const string EmailParameter4 = "<MA DON HANG>";
        public const string EmailNewLine = "<br />";

        public const string SmsParameter1 = "<SMSNAME>";
        public const string SmsParameter2 = "<MOBILE>";
        public const string SmsParameter3 = "<TIME>";
        public const string SmsParameter4 = "<RECIPIENT>";

        public const string OrderStatusDraft = "Nhận đơn hàng từ khách";
        public const string OrderStatusDelivering = "Đang vận chuyển hàng";
        public const string OrderStatusDelivered = "Đã chuyển hàng";
        public const string DeliveryStatusDraft = "Chưa chuyển hàng";
        public const string DeliveryStatusDelivered = "Đã chuyển hàng";

        public const string DeliverySentSms = "Đã gửi";
        public const string DeliverySendSms = "Chưa gửi";
        public const string DeliverySendSmsFail = "Gửi lỗi";
        public const string DeliverySentEmail = "Đã gửi";
        public const string DeliverySendEmail = "Chưa gửi";
        public const string DeliverySendEmailFail = "Gửi lỗi";

        public const string ConfigurationSMsPort = "SMS_Port";
        public const string ConfigurationSMsBaudRate = "SMS_BaudRate";
        public const string ConfigurationSMsDataBits = "SMS_DataBits";
        public const string ConfigurationSMsReadTimeout = "SMS_ReadTimeout";
        public const string ConfigurationSMsWriteTimeout = "SMS_WriteTimeout";

        public const string MessageSmsConfigError = "Lỗi hệ thống gửi tin nhắn qua SMS. Liên hệ admin để giải quyết.";
        public const string MessageEmailNotExistError = "Không tìm thấy template mail";

        public const string LockedStatus = "Locked";
    }
}
